import xlrd


class AddCardData:
    # 打开测试数据excel表
    book = xlrd.open_workbook(filename='D:/工作/2023年6月/test_data.xlsx')

    st = book.sheet_by_index(7)

    row_num = st.nrows

    addcard_data = []
    for i in range(1, row_num):
        data = st.row_values(i)
        addcard_data.append(data)

    st = book.sheet_by_index(8)

    row_num = st.nrows

    for i in range(1, row_num):
        data = st.row_values(i)
        addcard_data.append(data)

    st = book.sheet_by_index(9)

    row_num = st.nrows

    for i in range(1, row_num):
        data = st.row_values(i)
        addcard_data.append(data)

    st = book.sheet_by_index(10)

    row_num = st.nrows

    for i in range(1, row_num):
        data = st.row_values(i)
        addcard_data.append(data)
